Industrial Engineeringlab
DATA ANALYTICS AND VISUALIZATION LAB
MIE 2143
Syllabus
- 01Introduction to spreadsheets
- 02basics of formula and functions
- 03Data cleaning and wrangling
- 04Data sorting
- 05filtering and Lookup using spreadsheets
- 06Data visualizing using spreadsheet
- 07descriptive statistics
- 082-sample and paired t-test
- 09Correlation test
- 10Covariance test
- 11Analysis of variance (ANOVA) tests
- 12Regression analysis
References
- Montgomery, D. C., Design and Analysis of Experiments. United Kingdom, John Wiley & Sons, Limited, 2021.
- Ragsdale, C., Spreadsheet Modelling & Decision Analysis: A Practical Introduction to Business Analytics. United States, Cengage Learning, 2021.
- Jones, B. and Goos, P., Optimal Design of Experiments: A Case Study Approach. United Kingdom, Wiley, 2011.
Credits Structure
0Lecture
0Tutorial
3Practical
1Total